use GSI_Ap2


create table tc (i int primary key,
                 j char(5000)
                 )

    
set nocount on           
declare @i int
set @i = 0
while @i < 10000
begin
   insert into tc values(@i, REPLICATE(cast(@i as nvarchar),5000))
   set @i = @i + 1
end     




dbcc checktable ('TC')
       
EXEC sp_estimate_data_compression_savings
      'dbo', 'tc', NULL, NULL, 'ROW' 


alter table tc rebuild  with (DATA_COMPRESSION = ROW)

dbcc checktable ('TC')

DBCC IND ('GSI',Tc,-1)

DBCC TRACEON (3604)
DBCC PAGE ('GSI', 1, 29302,3)
